Tabela ServiceRealCost

Definicja tabeli ServiceRealCost

Name

ServiceRealCost

Code

ServiceRealCost

Comment

Koszty rzeczywiste uslug


Lista kolumn tabeli ServiceRealCost

Name

Code

CostAccountID

CostAccountID

PeriodID

PeriodID

ServID

ServID

ServiceComponentID

ServiceComponentID

DCDrugs

DCDrugs

DCPersonel

DCPersonel

DCMaterials

DCMaterials

DCOther

DCOther

DCAdministration

DCAdministration

ICDrugs

ICDrugs

ICPersonel

ICPersonel

ICMaterials

ICMaterials

ICOther

ICOther

ICAdministration

ICAdministration

UnitsCount

UnitsCount


Kolumna CostAccountID tabeli ServiceRealCost

Definicja kolumny CostAccountID tabeli ServiceRealCost

Name

CostAccountID

Code

CostAccountID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PeriodID tabeli ServiceRealCost

Definicja kolumny PeriodID tabeli ServiceRealCost

Name

PeriodID

Code

PeriodID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli ServiceRealCost

Definicja kolumny ServID tabeli ServiceRealCost

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServiceComponentID tabeli ServiceRealCost

Definicja kolumny ServiceComponentID tabeli ServiceRealCost

Name

ServiceComponentID

Code

ServiceComponentID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DCDrugs tabeli ServiceRealCost

Definicja kolumny DCDrugs tabeli ServiceRealCost

Name

DCDrugs

Code

DCDrugs

Data Type

FLOAT(48)

Mandatory

No

Comment

koszt bezposredni leków


Kolumna DCPersonel tabeli ServiceRealCost

Definicja kolumny DCPersonel tabeli ServiceRealCost

Name

DCPersonel

Code

DCPersonel

Data Type

FLOAT(48)

Mandatory

No

Comment

koszt bezposredni personelu


Kolumna DCMaterials tabeli ServiceRealCost

Definicja kolumny DCMaterials tabeli ServiceRealCost

Name

DCMaterials

Code

DCMaterials

Data Type

FLOAT(48)

Mandatory

No

Comment

koszt bezposredni materialowy


Kolumna DCOther tabeli ServiceRealCost

Definicja kolumny DCOther tabeli ServiceRealCost

Name

DCOther

Code

DCOther

Data Type

FLOAT(48)

Mandatory

No

Comment

koszt bezposredni inny


Kolumna DCAdministration tabeli ServiceRealCost

Definicja kolumny DCAdministration tabeli ServiceRealCost

Name

DCAdministration

Code

DCAdministration

Data Type

FLOAT(48)

Mandatory

No

Comment

koszt bezposredni administracji


Kolumna ICDrugs tabeli ServiceRealCost

Definicja kolumny ICDrugs tabeli ServiceRealCost

Name

ICDrugs

Code

ICDrugs

Data Type

FLOAT(48)

Mandatory

No

Comment

koszt posredni leków


Kolumna ICPersonel tabeli ServiceRealCost

Definicja kolumny ICPersonel tabeli ServiceRealCost

Name

ICPersonel

Code

ICPersonel

Data Type

FLOAT(48)

Mandatory

No

Comment

koszt posredni personelu


Kolumna ICMaterials tabeli ServiceRealCost

Definicja kolumny ICMaterials tabeli ServiceRealCost

Name

ICMaterials

Code

ICMaterials

Data Type

FLOAT(48)

Mandatory

No

Comment

koszt posredni materialowy


Kolumna ICOther tabeli ServiceRealCost

Definicja kolumny ICOther tabeli ServiceRealCost

Name

ICOther

Code

ICOther

Data Type

FLOAT(48)

Mandatory

No

Comment

koszt posredni inny


Kolumna ICAdministration tabeli ServiceRealCost

Definicja kolumny ICAdministration tabeli ServiceRealCost

Name

ICAdministration

Code

ICAdministration

Data Type

FLOAT(48)

Mandatory

No

Comment

koszt posredni administracji


Kolumna UnitsCount tabeli ServiceRealCost

Definicja kolumny UnitsCount tabeli ServiceRealCost

Name

UnitsCount

Code

UnitsCount

Data Type

FLOAT

Mandatory

No

Comment

ilosc wykonan


Lista kluczy tabeli ServiceRealCost

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ServiceRealCost

Definicja klucza Identifier_1 tabeli ServiceRealCost

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment